<?php
/**
 */
class REQ_UNIVERSITYTable extends Doctrine_Table
{

	/**
	 * 
	 * @param $lc
	 * @return unknown_type
	 */
	public function getUniversityByLC($lc)
	{
		$q = $this->createQuery()
		->from('REQ_UNIVERSITY U')
		->leftjoin('U.REQ_LC_UNIVERSITY LCU')
		->where('LCU.ID_REQ_LC = ?', $lc);
		return $q->getSql();
	}
	
}